CREATE PROCEDURE [dbo].[sp_cat_GetResource]
@Resource varchar(50) = NULL, @PKResource int = NULL
AS
BEGIN
  SELECT PKResource , Resource FROM SC_Resource
  WHERE PKResource = COALESCE(@PKResource , PKResource)
  AND Resource = COALESCE(@Resource , Resource)
  ORDER BY Resource;
END